1.
SELECT name, day, month
FROM namsday
WHERE WEEK(STR_TO_DATE(CONCAT(day, '.', month, '.2025'), '%d.%m.%Y')) =
WEEK(STR_TO_DATE('01.03.2025', '%d.%m.%Y'));
2.SELECT name, day, month
FROM namsday
WHERE CHAR_LENGTH(name) = 6;
3.SELECT name, day, month
FROM namsday
WHERE CHAR_LENGTH(name) = 10;
4.SELECT name, day, month
FROM namsday
WHERE name LIKE 'E%s';
5.SELECT name, day, month
FROM namsday
WHERE name LIKE 's%';
6.SELECT name, day, month
FROM namsday
WHERE month = 4;
7.SELECT name, day, month
FROM namsday
WHERE name LIKE 'E%'
ORDER BY month DESC, day ASC;
8.SELECT name, day, month
FROM namsday
WHERE name LIKE 's%' AND month = 3;
